﻿<%@ Page Title="" Language="C#" MasterPageFile="~/Site.Master" AutoEventWireup="true" CodeBehind="CLIENTES.aspx.cs" Inherits="PC_AYUDA.Formulario_web1" %>
<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" runat="server">
    <style type="text/css">
    .style3
    {
        width: 100%;
        background-image: url('Account/imagenes/CLIENTE.jpg');
        height: 279px;
        margin-left: 0px;
    }
    .style7
    {
        height: 72px;
        width: 617px;
    }
    .style9
    {
        height: 72px;
        width: 305px;
    }
        .style12
        {
            height: 90px;
            width: 305px;
        }
        .style13
        {
            height: 90px;
            width: 617px;
        }
        .style14
        {
            height: 85px;
            width: 305px;
        }
        .style15
        {
            height: 85px;
            width: 617px;
        }
        .style16
        {
            height: 80px;
            width: 305px;
        }
        .style17
        {
            height: 80px;
            width: 617px;
        }
        .style18
        {
            height: 88px;
            width: 305px;
        }
        .style19
        {
            height: 88px;
            width: 617px;
        }
        .style20
        {
            height: 84px;
            width: 305px;
        }
        .style21
        {
            height: 84px;
            width: 617px;
        }
        .style22
        {
            height: 87px;
            width: 305px;
        }
        .style23
        {
            height: 87px;
            width: 617px;
        }
    </style>
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="server">
    <table class="style3">
    <tr>
        <td class="style12">
            <asp:Label ID="ID_CLIENT" runat="server" Text="ID_CLIENTES"></asp:Label>
        </td>
        <td class="style13">
            <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
        </td>
    </tr>
    <tr>
        <td class="style9">
            <asp:Label ID="NOMBRES" runat="server" Text="NOMBRES"></asp:Label>
        </td>
        <td class="style7">
            <asp:TextBox ID="TextBox2" runat="server"></asp:TextBox>
        </td>
    </tr>
    <tr>
        <td class="style14">
            <asp:Label ID="APELLIDOS" runat="server" Text="APELLIDOS"></asp:Label>
        </td>
        <td class="style15">
            <asp:TextBox ID="TextBox3" runat="server"></asp:TextBox>
        </td>
    </tr>
    <tr>
        <td class="style16">
            <asp:Label ID="DIRECCION" runat="server" Text="DIRECCION"></asp:Label>
        </td>
        <td class="style17">
            <asp:TextBox ID="TextBox4" runat="server"></asp:TextBox>
        </td>
    </tr>
    <tr>
        <td class="style18">
            <asp:Label ID="TELEFONOS" runat="server" Text="TELEFONOS"></asp:Label>
        </td>
        <td class="style19">
            <asp:TextBox ID="TextBox5" runat="server"></asp:TextBox>
        </td>
    </tr>
    <tr>
        <td class="style20">
            <asp:Label ID="CELULAR" runat="server" Text="CELULAR"></asp:Label>
        </td>
        <td class="style21">
            <asp:TextBox ID="TextBox6" runat="server"></asp:TextBox>
        </td>
    </tr>
    <tr>
        <td class="style22">
            <asp:Label ID="CEDULA" runat="server" Text="EDULA"></asp:Label>
        </td>
        <td class="style23">
            <asp:TextBox ID="TextBox7" runat="server" Width="129px"></asp:TextBox>
            <asp:Button ID="INGRESAR" runat="server" Text="INGRESAR NUEVO REGISTRO" 
                Width="219px" />
        </td>
    </tr>
</table>
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" 
    DataKeyNames="ID_CLIENTE" DataSourceID="SqlDataSource1" 
    EmptyDataText="No hay registros de datos para mostrar." Width="926px">
    <Columns>
        <asp:BoundField DataField="ID_CLIENTE" HeaderText="ID_CLIENTE" ReadOnly="True" 
            SortExpression="ID_CLIENTE" />
        <asp:BoundField DataField="NOMBRES" HeaderText="NOMBRES" 
            SortExpression="NOMBRES" />
        <asp:BoundField DataField="APELLIDOS" HeaderText="APELLIDOS" 
            SortExpression="APELLIDOS" />
        <asp:BoundField DataField="DIRECCION" HeaderText="DIRECCION" 
            SortExpression="DIRECCION" />
        <asp:BoundField DataField="TLEFONOS" HeaderText="TLEFONOS" 
            SortExpression="TLEFONOS" />
        <asp:BoundField DataField="CELULAR" HeaderText="CELULAR" 
            SortExpression="CELULAR" />
        <asp:BoundField DataField="CEDULA" HeaderText="CEDULA" 
            SortExpression="CEDULA" />
    </Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" 
    ConnectionString="<%$ ConnectionStrings:PC-PARTESConnectionString %>" 
    DeleteCommand="DELETE FROM [CLIENTE] WHERE [ID_CLIENTE] = @ID_CLIENTE" 
    InsertCommand="INSERT INTO [CLIENTE] ([ID_CLIENTE], [NOMBRES], [APELLIDOS], [DIRECCION], [TLEFONOS], [CELULAR], [CEDULA]) VALUES (@ID_CLIENTE, @NOMBRES, @APELLIDOS, @DIRECCION, @TLEFONOS, @CELULAR, @CEDULA)" 
    ProviderName="<%$ ConnectionStrings:PC-PARTESConnectionString.ProviderName %>" 
    SelectCommand="SELECT [ID_CLIENTE], [NOMBRES], [APELLIDOS], [DIRECCION], [TLEFONOS], [CELULAR], [CEDULA] FROM [CLIENTE]" 
    UpdateCommand="UPDATE [CLIENTE] SET [NOMBRES] = @NOMBRES, [APELLIDOS] = @APELLIDOS, [DIRECCION] = @DIRECCION, [TLEFONOS] = @TLEFONOS, [CELULAR] = @CELULAR, [CEDULA] = @CEDULA WHERE [ID_CLIENTE] = @ID_CLIENTE">
    <DeleteParameters>
        <asp:Parameter Name="ID_CLIENTE" Type="String" />
    </DeleteParameters>
    <InsertParameters>
        <asp:Parameter Name="ID_CLIENTE" Type="String" />
        <asp:Parameter Name="NOMBRES" Type="String" />
        <asp:Parameter Name="APELLIDOS" Type="String" />
        <asp:Parameter Name="DIRECCION" Type="String" />
        <asp:Parameter Name="TLEFONOS" Type="String" />
        <asp:Parameter Name="CELULAR" Type="String" />
        <asp:Parameter Name="CEDULA" Type="String" />
    </InsertParameters>
    <UpdateParameters>
        <asp:Parameter Name="NOMBRES" Type="String" />
        <asp:Parameter Name="APELLIDOS" Type="String" />
        <asp:Parameter Name="DIRECCION" Type="String" />
        <asp:Parameter Name="TLEFONOS" Type="String" />
        <asp:Parameter Name="CELULAR" Type="String" />
        <asp:Parameter Name="CEDULA" Type="String" />
        <asp:Parameter Name="ID_CLIENTE" Type="String" />
    </UpdateParameters>
</asp:SqlDataSource>
<br />
</asp:Content>
